-
Re: IF/AND Statement using text & checkbox
I am assuming that your "In AOP" column is a checkbox column and that the column where you are placing the formula is also a checkbox column. If that's true, this should do it: =IF(AND([Emp…1 · -
Re: IF Statement?
Not sure how you have your columns formatted, so there may be more efficient way to go, but I think this will work for you: =COUNTIFS([Request Status]:[Request Status], "Open", [Month Opene…1 · -
Re: List all unique values from a column within one Smartsheet in a separate Smartsheet
@Cleversheet - this is phenomenal workaround. I found this answer looking for something else and immediately put it to use. Thank you!1 · -
Re: Analyzing Text for Special Characters in a Conditional Formula
1 ·